<test>
  <sql>SELECT	*
FROM	Suppliers</sql>
  <expectedResults>
    <NewDataSet>
  <xs:schema id="NewDataSet" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="Table1">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="SupplierID" type="xs:int" minOccurs="0" />
                <xs:element name="CompanyName" type="xs:string" minOccurs="0" />
                <xs:element name="ContactName" type="xs:string" minOccurs="0" />
                <xs:element name="ContactTitle" type="xs:string" minOccurs="0" />
                <xs:element name="Address" type="xs:string" minOccurs="0" />
                <xs:element name="City" type="xs:string" minOccurs="0" />
                <xs:element name="Region" type="xs:string" minOccurs="0" />
                <xs:element name="PostalCode" type="xs:string" minOccurs="0" />
                <xs:element name="Country" type="xs:string" minOccurs="0" />
                <xs:element name="Phone" type="xs:string" minOccurs="0" />
                <xs:element name="Fax" type="xs:string" minOccurs="0" />
                <xs:element name="HomePage" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <Table1>
    <SupplierID>1</SupplierID>
    <CompanyName>Exotic Liquids</CompanyName>
    <ContactName>Charlotte Cooper</ContactName>
    <ContactTitle>Purchasing Manager</ContactTitle>
    <Address>49 Gilbert St.</Address>
    <City>London</City>
    <PostalCode>EC1 4SD</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-2222</Phone>
  </Table1>
  <Table1>
    <SupplierID>2</SupplierID>
    <CompanyName>New Orleans Cajun Delights</CompanyName>
    <ContactName>Shelley Burke</ContactName>
    <ContactTitle>Order Administrator</ContactTitle>
    <Address>P.O. Box 78934</Address>
    <City>New Orleans</City>
    <Region>LA</Region>
    <PostalCode>70117</PostalCode>
    <Country>USA</Country>
    <Phone>(100) 555-4822</Phone>
    <HomePage>#CAJUN.HTM#</HomePage>
  </Table1>
  <Table1>
    <SupplierID>3</SupplierID>
    <CompanyName>Grandma Kelly's Homestead</CompanyName>
    <ContactName>Regina Murphy</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>707 Oxford Rd.</Address>
    <City>Ann Arbor</City>
    <Region>MI</Region>
    <PostalCode>48104</PostalCode>
    <Country>USA</Country>
    <Phone>(313) 555-5735</Phone>
    <Fax>(313) 555-3349</Fax>
  </Table1>
  <Table1>
    <SupplierID>4</SupplierID>
    <CompanyName>Tokyo Traders</CompanyName>
    <ContactName>Yoshi Nagase</ContactName>
    <ContactTitle>Marketing Manager</ContactTitle>
    <Address>9-8 Sekimai Musashino-shi</Address>
    <City>Tokyo</City>
    <PostalCode>100</PostalCode>
    <Country>Japan</Country>
    <Phone>(03) 3555-5011</Phone>
  </Table1>
  <Table1>
    <SupplierID>5</SupplierID>
    <CompanyName>Cooperativa de Quesos 'Las Cabras'</CompanyName>
    <ContactName>Antonio del Valle Saavedra</ContactName>
    <ContactTitle>Export Administrator</ContactTitle>
    <Address>Calle del Rosal 4</Address>
    <City>Oviedo</City>
    <Region>Asturias</Region>
    <PostalCode>33007</PostalCode>
    <Country>Spain</Country>
    <Phone>(98) 598 76 54</Phone>
  </Table1>
  <Table1>
    <SupplierID>6</SupplierID>
    <CompanyName>Mayumi's</CompanyName>
    <ContactName>Mayumi Ohno</ContactName>
    <ContactTitle>Marketing Representative</ContactTitle>
    <Address>92 Setsuko Chuo-ku</Address>
    <City>Osaka</City>
    <PostalCode>545</PostalCode>
    <Country>Japan</Country>
    <Phone>(06) 431-7877</Phone>
    <HomePage>Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#</HomePage>
  </Table1>
  <Table1>
    <SupplierID>7</SupplierID>
    <CompanyName>Pavlova, Ltd.</CompanyName>
    <ContactName>Ian Devling</ContactName>
    <ContactTitle>Marketing Manager</ContactTitle>
    <Address>74 Rose St. Moonie Ponds</Address>
    <City>Melbourne</City>
    <Region>Victoria</Region>
    <PostalCode>3058</PostalCode>
    <Country>Australia</Country>
    <Phone>(03) 444-2343</Phone>
    <Fax>(03) 444-6588</Fax>
  </Table1>
  <Table1>
    <SupplierID>8</SupplierID>
    <CompanyName>Specialty Biscuits, Ltd.</CompanyName>
    <ContactName>Peter Wilson</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>29 King's Way</Address>
    <City>Manchester</City>
    <PostalCode>M14 GSD</PostalCode>
    <Country>UK</Country>
    <Phone>(161) 555-4448</Phone>
  </Table1>
  <Table1>
    <SupplierID>9</SupplierID>
    <CompanyName>PB Knäckebröd AB</CompanyName>
    <ContactName>Lars Peterson</ContactName>
    <ContactTitle>Sales Agent</ContactTitle>
    <Address>Kaloadagatan 13</Address>
    <City>Göteborg</City>
    <PostalCode>S-345 67</PostalCode>
    <Country>Sweden</Country>
    <Phone>031-987 65 43</Phone>
    <Fax>031-987 65 91</Fax>
  </Table1>
  <Table1>
    <SupplierID>10</SupplierID>
    <CompanyName>Refrescos Americanas LTDA</CompanyName>
    <ContactName>Carlos Diaz</ContactName>
    <ContactTitle>Marketing Manager</ContactTitle>
    <Address>Av. das Americanas 12.890</Address>
    <City>Sao Paulo</City>
    <PostalCode>5442</PostalCode>
    <Country>Brazil</Country>
    <Phone>(11) 555 4640</Phone>
  </Table1>
  <Table1>
    <SupplierID>11</SupplierID>
    <CompanyName>Heli Süßwaren GmbH &amp; Co. KG</CompanyName>
    <ContactName>Petra Winkler</ContactName>
    <ContactTitle>Sales Manager</ContactTitle>
    <Address>Tiergartenstraße 5</Address>
    <City>Berlin</City>
    <PostalCode>10785</PostalCode>
    <Country>Germany</Country>
    <Phone>(010) 9984510</Phone>
  </Table1>
  <Table1>
    <SupplierID>12</SupplierID>
    <CompanyName>Plutzer Lebensmittelgroßmärkte AG</CompanyName>
    <ContactName>Martin Bein</ContactName>
    <ContactTitle>International Marketing Mgr.</ContactTitle>
    <Address>Bogenallee 51</Address>
    <City>Frankfurt</City>
    <PostalCode>60439</PostalCode>
    <Country>Germany</Country>
    <Phone>(069) 992755</Phone>
    <HomePage>Plutzer (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/plutzer.htm#</HomePage>
  </Table1>
  <Table1>
    <SupplierID>13</SupplierID>
    <CompanyName>Nord-Ost-Fisch Handelsgesellschaft mbH</CompanyName>
    <ContactName>Sven Petersen</ContactName>
    <ContactTitle>Coordinator Foreign Markets</ContactTitle>
    <Address>Frahmredder 112a</Address>
    <City>Cuxhaven</City>
    <PostalCode>27478</PostalCode>
    <Country>Germany</Country>
    <Phone>(04721) 8713</Phone>
    <Fax>(04721) 8714</Fax>
  </Table1>
  <Table1>
    <SupplierID>14</SupplierID>
    <CompanyName>Formaggi Fortini s.r.l.</CompanyName>
    <ContactName>Elio Rossi</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>Viale Dante, 75</Address>
    <City>Ravenna</City>
    <PostalCode>48100</PostalCode>
    <Country>Italy</Country>
    <Phone>(0544) 60323</Phone>
    <Fax>(0544) 60603</Fax>
    <HomePage>#FORMAGGI.HTM#</HomePage>
  </Table1>
  <Table1>
    <SupplierID>15</SupplierID>
    <CompanyName>Norske Meierier</CompanyName>
    <ContactName>Beate Vileid</ContactName>
    <ContactTitle>Marketing Manager</ContactTitle>
    <Address>Hatlevegen 5</Address>
    <City>Sandvika</City>
    <PostalCode>1320</PostalCode>
    <Country>Norway</Country>
    <Phone>(0)2-953010</Phone>
  </Table1>
  <Table1>
    <SupplierID>16</SupplierID>
    <CompanyName>Bigfoot Breweries</CompanyName>
    <ContactName>Cheryl Saylor</ContactName>
    <ContactTitle>Regional Account Rep.</ContactTitle>
    <Address>3400 - 8th Avenue Suite 210</Address>
    <City>Bend</City>
    <Region>OR</Region>
    <PostalCode>97101</PostalCode>
    <Country>USA</Country>
    <Phone>(503) 555-9931</Phone>
  </Table1>
  <Table1>
    <SupplierID>17</SupplierID>
    <CompanyName>Svensk Sjöföda AB</CompanyName>
    <ContactName>Michael Björn</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>Brovallavägen 231</Address>
    <City>Stockholm</City>
    <PostalCode>S-123 45</PostalCode>
    <Country>Sweden</Country>
    <Phone>08-123 45 67</Phone>
  </Table1>
  <Table1>
    <SupplierID>18</SupplierID>
    <CompanyName>Aux joyeux ecclésiastiques</CompanyName>
    <ContactName>Guylène Nodier</ContactName>
    <ContactTitle>Sales Manager</ContactTitle>
    <Address>203, Rue des Francs-Bourgeois</Address>
    <City>Paris</City>
    <PostalCode>75004</PostalCode>
    <Country>France</Country>
    <Phone>(1) 03.83.00.68</Phone>
    <Fax>(1) 03.83.00.62</Fax>
  </Table1>
  <Table1>
    <SupplierID>19</SupplierID>
    <CompanyName>New England Seafood Cannery</CompanyName>
    <ContactName>Robb Merchant</ContactName>
    <ContactTitle>Wholesale Account Agent</ContactTitle>
    <Address>Order Processing Dept. 2100 Paul Revere Blvd.</Address>
    <City>Boston</City>
    <Region>MA</Region>
    <PostalCode>02134</PostalCode>
    <Country>USA</Country>
    <Phone>(617) 555-3267</Phone>
    <Fax>(617) 555-3389</Fax>
  </Table1>
  <Table1>
    <SupplierID>20</SupplierID>
    <CompanyName>Leka Trading</CompanyName>
    <ContactName>Chandra Leka</ContactName>
    <ContactTitle>Owner</ContactTitle>
    <Address>471 Serangoon Loop, Suite #402</Address>
    <City>Singapore</City>
    <PostalCode>0512</PostalCode>
    <Country>Singapore</Country>
    <Phone>555-8787</Phone>
  </Table1>
  <Table1>
    <SupplierID>21</SupplierID>
    <CompanyName>Lyngbysild</CompanyName>
    <ContactName>Niels Petersen</ContactName>
    <ContactTitle>Sales Manager</ContactTitle>
    <Address>Lyngbysild Fiskebakken 10</Address>
    <City>Lyngby</City>
    <PostalCode>2800</PostalCode>
    <Country>Denmark</Country>
    <Phone>43844108</Phone>
    <Fax>43844115</Fax>
  </Table1>
  <Table1>
    <SupplierID>22</SupplierID>
    <CompanyName>Zaanse Snoepfabriek</CompanyName>
    <ContactName>Dirk Luchte</ContactName>
    <ContactTitle>Accounting Manager</ContactTitle>
    <Address>Verkoop Rijnweg 22</Address>
    <City>Zaandam</City>
    <PostalCode>9999 ZZ</PostalCode>
    <Country>Netherlands</Country>
    <Phone>(12345) 1212</Phone>
    <Fax>(12345) 1210</Fax>
  </Table1>
  <Table1>
    <SupplierID>23</SupplierID>
    <CompanyName>Karkki Oy</CompanyName>
    <ContactName>Anne Heikkonen</ContactName>
    <ContactTitle>Product Manager</ContactTitle>
    <Address>Valtakatu 12</Address>
    <City>Lappeenranta</City>
    <PostalCode>53120</PostalCode>
    <Country>Finland</Country>
    <Phone>(953) 10956</Phone>
  </Table1>
  <Table1>
    <SupplierID>24</SupplierID>
    <CompanyName>G'day, Mate</CompanyName>
    <ContactName>Wendy Mackenzie</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>170 Prince Edward Parade Hunter's Hill</Address>
    <City>Sydney</City>
    <Region>NSW</Region>
    <PostalCode>2042</PostalCode>
    <Country>Australia</Country>
    <Phone>(02) 555-5914</Phone>
    <Fax>(02) 555-4873</Fax>
    <HomePage>G'day Mate (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/gdaymate.htm#</HomePage>
  </Table1>
  <Table1>
    <SupplierID>25</SupplierID>
    <CompanyName>Ma Maison</CompanyName>
    <ContactName>Jean-Guy Lauzon</ContactName>
    <ContactTitle>Marketing Manager</ContactTitle>
    <Address>2960 Rue St. Laurent</Address>
    <City>Montréal</City>
    <Region>Québec</Region>
    <PostalCode>H1J 1C3</PostalCode>
    <Country>Canada</Country>
    <Phone>(514) 555-9022</Phone>
  </Table1>
  <Table1>
    <SupplierID>26</SupplierID>
    <CompanyName>Pasta Buttini s.r.l.</CompanyName>
    <ContactName>Giovanni Giudici</ContactName>
    <ContactTitle>Order Administrator</ContactTitle>
    <Address>Via dei Gelsomini, 153</Address>
    <City>Salerno</City>
    <PostalCode>84100</PostalCode>
    <Country>Italy</Country>
    <Phone>(089) 6547665</Phone>
    <Fax>(089) 6547667</Fax>
  </Table1>
  <Table1>
    <SupplierID>27</SupplierID>
    <CompanyName>Escargots Nouveaux</CompanyName>
    <ContactName>Marie Delamare</ContactName>
    <ContactTitle>Sales Manager</ContactTitle>
    <Address>22, rue H. Voiron</Address>
    <City>Montceau</City>
    <PostalCode>71300</PostalCode>
    <Country>France</Country>
    <Phone>85.57.00.07</Phone>
  </Table1>
  <Table1>
    <SupplierID>28</SupplierID>
    <CompanyName>Gai pâturage</CompanyName>
    <ContactName>Eliane Noz</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>Bat. B 3, rue des Alpes</Address>
    <City>Annecy</City>
    <PostalCode>74000</PostalCode>
    <Country>France</Country>
    <Phone>38.76.98.06</Phone>
    <Fax>38.76.98.58</Fax>
  </Table1>
  <Table1>
    <SupplierID>29</SupplierID>
    <CompanyName>Forêts d'érables</CompanyName>
    <ContactName>Chantal Goulet</ContactName>
    <ContactTitle>Accounting Manager</ContactTitle>
    <Address>148 rue Chasseur</Address>
    <City>Ste-Hyacinthe</City>
    <Region>Québec</Region>
    <PostalCode>J2S 7S8</PostalCode>
    <Country>Canada</Country>
    <Phone>(514) 555-2955</Phone>
    <Fax>(514) 555-2921</Fax>
  </Table1>
</NewDataSet>
  </expectedResults>
  <expectedPlan>
    <executionPlan>
      <element operator="Select">
        <properties>
          <property name="Output List.[00]" value="Suppliers.SupplierID AS SupplierID" />
          <property name="Output List.[00].Table" value="Suppliers" />
          <property name="Output List.[00].Column" value="SupplierID" />
          <property name="Output List.[00].DataType" value="Int32" />
          <property name="Output List.[00].Output Name" value="SupplierID" />
          <property name="Output List.[01]" value="Suppliers.CompanyName AS CompanyName" />
          <property name="Output List.[01].Table" value="Suppliers" />
          <property name="Output List.[01].Column" value="CompanyName" />
          <property name="Output List.[01].DataType" value="String" />
          <property name="Output List.[01].Output Name" value="CompanyName" />
          <property name="Output List.[02]" value="Suppliers.ContactName AS ContactName" />
          <property name="Output List.[02].Table" value="Suppliers" />
          <property name="Output List.[02].Column" value="ContactName" />
          <property name="Output List.[02].DataType" value="String" />
          <property name="Output List.[02].Output Name" value="ContactName" />
          <property name="Output List.[03]" value="Suppliers.ContactTitle AS ContactTitle" />
          <property name="Output List.[03].Table" value="Suppliers" />
          <property name="Output List.[03].Column" value="ContactTitle" />
          <property name="Output List.[03].DataType" value="String" />
          <property name="Output List.[03].Output Name" value="ContactTitle" />
          <property name="Output List.[04]" value="Suppliers.Address AS Address" />
          <property name="Output List.[04].Table" value="Suppliers" />
          <property name="Output List.[04].Column" value="Address" />
          <property name="Output List.[04].DataType" value="String" />
          <property name="Output List.[04].Output Name" value="Address" />
          <property name="Output List.[05]" value="Suppliers.City AS City" />
          <property name="Output List.[05].Table" value="Suppliers" />
          <property name="Output List.[05].Column" value="City" />
          <property name="Output List.[05].DataType" value="String" />
          <property name="Output List.[05].Output Name" value="City" />
          <property name="Output List.[06]" value="Suppliers.Region AS Region" />
          <property name="Output List.[06].Table" value="Suppliers" />
          <property name="Output List.[06].Column" value="Region" />
          <property name="Output List.[06].DataType" value="String" />
          <property name="Output List.[06].Output Name" value="Region" />
          <property name="Output List.[07]" value="Suppliers.PostalCode AS PostalCode" />
          <property name="Output List.[07].Table" value="Suppliers" />
          <property name="Output List.[07].Column" value="PostalCode" />
          <property name="Output List.[07].DataType" value="String" />
          <property name="Output List.[07].Output Name" value="PostalCode" />
          <property name="Output List.[08]" value="Suppliers.Country AS Country" />
          <property name="Output List.[08].Table" value="Suppliers" />
          <property name="Output List.[08].Column" value="Country" />
          <property name="Output List.[08].DataType" value="String" />
          <property name="Output List.[08].Output Name" value="Country" />
          <property name="Output List.[09]" value="Suppliers.Phone AS Phone" />
          <property name="Output List.[09].Table" value="Suppliers" />
          <property name="Output List.[09].Column" value="Phone" />
          <property name="Output List.[09].DataType" value="String" />
          <property name="Output List.[09].Output Name" value="Phone" />
          <property name="Output List.[10]" value="Suppliers.Fax AS Fax" />
          <property name="Output List.[10].Table" value="Suppliers" />
          <property name="Output List.[10].Column" value="Fax" />
          <property name="Output List.[10].DataType" value="String" />
          <property name="Output List.[10].Output Name" value="Fax" />
          <property name="Output List.[11]" value="Suppliers.HomePage AS HomePage" />
          <property name="Output List.[11].Table" value="Suppliers" />
          <property name="Output List.[11].Column" value="HomePage" />
          <property name="Output List.[11].DataType" value="String" />
          <property name="Output List.[11].Output Name" value="HomePage" />
        </properties>
        <input>
          <element operator="TableScan">
            <properties>
              <property name="Table" value="Suppliers AS Suppliers" />
              <property name="Output List.[00]" value="Suppliers.SupplierID" />
              <property name="Output List.[00].Table" value="Suppliers" />
              <property name="Output List.[00].Column" value="SupplierID" />
              <property name="Output List.[00].DataType" value="Int32" />
              <property name="Output List.[01]" value="Suppliers.CompanyName" />
              <property name="Output List.[01].Table" value="Suppliers" />
              <property name="Output List.[01].Column" value="CompanyName" />
              <property name="Output List.[01].DataType" value="String" />
              <property name="Output List.[02]" value="Suppliers.ContactName" />
              <property name="Output List.[02].Table" value="Suppliers" />
              <property name="Output List.[02].Column" value="ContactName" />
              <property name="Output List.[02].DataType" value="String" />
              <property name="Output List.[03]" value="Suppliers.ContactTitle" />
              <property name="Output List.[03].Table" value="Suppliers" />
              <property name="Output List.[03].Column" value="ContactTitle" />
              <property name="Output List.[03].DataType" value="String" />
              <property name="Output List.[04]" value="Suppliers.Address" />
              <property name="Output List.[04].Table" value="Suppliers" />
              <property name="Output List.[04].Column" value="Address" />
              <property name="Output List.[04].DataType" value="String" />
              <property name="Output List.[05]" value="Suppliers.City" />
              <property name="Output List.[05].Table" value="Suppliers" />
              <property name="Output List.[05].Column" value="City" />
              <property name="Output List.[05].DataType" value="String" />
              <property name="Output List.[06]" value="Suppliers.Region" />
              <property name="Output List.[06].Table" value="Suppliers" />
              <property name="Output List.[06].Column" value="Region" />
              <property name="Output List.[06].DataType" value="String" />
              <property name="Output List.[07]" value="Suppliers.PostalCode" />
              <property name="Output List.[07].Table" value="Suppliers" />
              <property name="Output List.[07].Column" value="PostalCode" />
              <property name="Output List.[07].DataType" value="String" />
              <property name="Output List.[08]" value="Suppliers.Country" />
              <property name="Output List.[08].Table" value="Suppliers" />
              <property name="Output List.[08].Column" value="Country" />
              <property name="Output List.[08].DataType" value="String" />
              <property name="Output List.[09]" value="Suppliers.Phone" />
              <property name="Output List.[09].Table" value="Suppliers" />
              <property name="Output List.[09].Column" value="Phone" />
              <property name="Output List.[09].DataType" value="String" />
              <property name="Output List.[10]" value="Suppliers.Fax" />
              <property name="Output List.[10].Table" value="Suppliers" />
              <property name="Output List.[10].Column" value="Fax" />
              <property name="Output List.[10].DataType" value="String" />
              <property name="Output List.[11]" value="Suppliers.HomePage" />
              <property name="Output List.[11].Table" value="Suppliers" />
              <property name="Output List.[11].Column" value="HomePage" />
              <property name="Output List.[11].DataType" value="String" />
              <property name="Statistics.Open Count" value="1" />
              <property name="Statistics.Row Count" value="29" />
              <property name="Statistics.Average Row Count" value="29" />
            </properties>
            <input />
          </element>
        </input>
      </element>
    </executionPlan>
  </expectedPlan>
</test>